
create external  table jms_dwd.dwd_tab_ops_customer_label_base_dt
(
  id                  bigint,
  customer_name       string,
  customer_phone      string,
  customer_label_code string,
  customer_label_name string,
  network_code        string,
  network_name        string,
  created_time        TIMESTAMP,
  created_staff_code  string,
  created_staff_name  string,
  updated_time        TIMESTAMP,
  updated_staff_code  string,
  updated_staff_name  string,
  agent_area_code     string,
  agent_area_name     string,
  franchisee_code     string,
  franchisee_name     string,
  del_flag            tinyint,
  customer_impression string
)comment '客户逆向标签表'
 PARTITIONED BY (
  `dt` string COMMENT '时间分区')
ROW FORMAT SERDE
  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
  '/dw/hive/jms_dwd.db/external/dwd_tab_ops_customer_label_base_dt';